package com.itheima.mapper;

import com.itheima.pojo.Category;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * @author panweiwei
 */
@Mapper
public interface CategoryMapper {
    /**
     * 新增分类
     *
     * @param category 分类信息
     */
    @Insert("insert into category(category_name, category_alias, create_user, create_time, update_time)" +
            "values (#{categoryName},#{categoryAlias},#{createUser},#{createTime},#{updateTime})")
    void add(Category category);

    /**
     * 查询分类列表
     *
     * @param id
     * @return
     */
    @Select("select * from category where create_user = #{id}")
    List<Category> list(Integer id);

    /**
     * 获取文章详情
     *
     * @param id 文章id
     * @return 文章详情
     */
    @Select("select * from category where id =#{id}")
    Category findById(Integer id);

    /**
     * 修改文章分类
     *
     * @param category
     * @return
     */
    @Update("update category set category_name =#{categoryName},category_alias = #{categoryAlias},update_time =#{updateTime} where id = #{id}")
    void update(Category category);

    /**
     * 删除文章分类
     *
     * @param categoryId 文章分类id
     * @return
     */
    @Delete("delete from category where id =#{categoryId}")
    void deleteById(Integer categoryId);
}
